Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	38821
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.0 MiB
Average record size in memory	163.2 B

Variable types

Numeric	10
Categorical	6

Alerts

`name` has a high cardinality: 38244 distinct values	High cardinality
`host_name` has a high cardinality: 9885 distinct values	High cardinality
`neighbourhood` has a high cardinality: 218 distinct values	High cardinality
`last_review` has a high cardinality: 1764 distinct values	High cardinality
`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`price` is highly skewed (γ1 = 23.6735943)	Skewed
`minimum_nights` is highly skewed (γ1 = 27.54218703)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`availability_365` has 12675 (32.6%) zeros	Zeros

Reproduction

Analysis started	2023-02-26 11:54:58.138611
Analysis finished	2023-02-26 11:55:10.942395
Duration	12.8 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	38821
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18100808

Minimum	2539
Maximum	36455809
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	2539
5-th percentile	905425
Q1	8721444
median	18872858
Q3	27567455
95-th percentile	34337649
Maximum	36455809
Range	36453270
Interquartile range (IQR)	18846011

Descriptive statistics

Standard deviation	10693722
Coefficient of variation (CV)	0.59078701
Kurtosis	-1.2036177
Mean	18100808
Median Absolute Deviation (MAD)	9404082
Skewness	-0.071215349
Sum	7.0269148 × 10¹¹
Variance	1.143557 × 10¹⁴
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2539	1	< 0.1%
24082591	1	< 0.1%
24083340	1	< 0.1%
24083686	1	< 0.1%
24083746	1	< 0.1%
24085451	1	< 0.1%
24086178	1	< 0.1%
24086457	1	< 0.1%
24086562	1	< 0.1%
24086704	1	< 0.1%
Other values (38811)	38811	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2539	1	< 0.1%
2595	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5099	1	< 0.1%
5121	1	< 0.1%
5178	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5295	1	< 0.1%

Value	Count	Frequency (%)
36455809	1	< 0.1%
36442252	1	< 0.1%
36438336	1	< 0.1%
36427429	1	< 0.1%
36425863	1	< 0.1%
36413632	1	< 0.1%
36411407	1	< 0.1%
36390226	1	< 0.1%
36351543	1	< 0.1%
36351128	1	< 0.1%

name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	38244
Distinct (%)	98.5%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

Home away from home	12
Loft Suite @ The Box House Hotel	11
Private Room	10
#NAME?	10
Brooklyn Apartment	9
Other values (38239)	38769

Length

Max length	161
Median length	73
Mean length	36.975245
Min length	1

Characters and Unicode

Total characters	1435416
Distinct characters	677
Distinct categories	20 ?
Distinct scripts	11 ?
Distinct blocks	17 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	37852 ?
Unique (%)	97.5%

Sample

1st row	Clean & quiet apt home by the park
2nd row	Skylit Midtown Castle
3rd row	Cozy Entire Floor of Brownstone
4th row	Entire Apt: Spacious Studio/Loft by central park
5th row	Large Cozy 1 BR Apartment In Midtown East

Common Values

Value	Count	Frequency (%)
Home away from home	12	< 0.1%
Loft Suite @ The Box House Hotel	11	< 0.1%
Private Room	10	< 0.1%
#NAME?	10	< 0.1%
Brooklyn Apartment	9	< 0.1%
Private room	8	< 0.1%
Cozy Brooklyn Apartment	8	< 0.1%
New york Multi-unit building	8	< 0.1%
Hillside Hotel	7	< 0.1%
Harlem Gem	7	< 0.1%
Other values (38234)	38731	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	13290	5.6%
room	8060	3.4%
	6622	2.8%
bedroom	5951	2.5%
private	5943	2.5%
apartment	5317	2.2%
cozy	4161	1.8%
apt	3716	1.6%
brooklyn	3365	1.4%
to	3213	1.4%
Other values (10708)	177579	74.9%

Most occurring characters

Value	Count	Frequency (%)
	199762	13.9%
e	98850	6.9%
o	97484	6.8%
t	84336	5.9%
a	82792	5.8%
r	77952	5.4%
i	75406	5.3%
n	75298	5.2%
l	41039	2.9%
m	39024	2.7%
Other values (667)	563473	39.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	959266	66.8%
Uppercase Letter	216415	15.1%
Space Separator	199764	13.9%
Other Punctuation	27473	1.9%
Decimal Number	19365	1.3%
Dash Punctuation	5499	0.4%
Other Letter	1894	0.1%
Math Symbol	1884	0.1%
Close Punctuation	1265	0.1%
Open Punctuation	1143	0.1%
Other values (10)	1448	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
房	70	3.7%
中	38	2.0%
家	37	2.0%
拉	35	1.8%
法	34	1.8%
盛	34	1.8%
间	32	1.7%
的	29	1.5%
约	23	1.2%
心	23	1.2%
Other values (438)	1539	81.3%

Lowercase Letter

Value	Count	Frequency (%)
e	98850	10.3%
o	97484	10.2%
t	84336	8.8%
a	82792	8.6%
r	77952	8.1%
i	75406	7.9%
n	75298	7.8%
l	41039	4.3%
m	39024	4.1%
s	38348	4.0%
Other values (52)	248737	25.9%

Other Symbol

Value	Count	Frequency (%)
★	232	31.9%
❤	154	21.2%
☆	100	13.7%
⭐	34	4.7%
♥	32	4.4%
✨	17	2.3%
✿	13	1.8%
☀	12	1.6%
✴	11	1.5%
✪	8	1.1%
Other values (44)	115	15.8%

Uppercase Letter

Value	Count	Frequency (%)
B	23894	11.0%
S	20958	9.7%
C	17108	7.9%
A	15730	7.3%
R	14162	6.5%
P	11887	5.5%
E	11571	5.3%
L	11320	5.2%
M	9491	4.4%
N	9381	4.3%
Other values (28)	70913	32.8%

Other Punctuation

Value	Count	Frequency (%)
,	7341	26.7%
!	6408	23.3%
/	4070	14.8%
.	3560	13.0%
&	2719	9.9%
'	902	3.3%
*	833	3.0%
:	507	1.8%
#	468	1.7%
"	256	0.9%
Other values (11)	409	1.5%

Math Symbol

Value	Count	Frequency (%)
+	979	52.0%
\|	635	33.7%
~	194	10.3%
=	27	1.4%
>	22	1.2%
<	14	0.7%
￫	6	0.3%
⋆	3	0.2%
√	2	0.1%
⊹	1	0.1%

Decimal Number

Value	Count	Frequency (%)
1	6577	34.0%
2	5348	27.6%
3	1986	10.3%
5	1691	8.7%
0	1659	8.6%
4	967	5.0%
6	365	1.9%
7	317	1.6%
8	265	1.4%
9	190	1.0%

Close Punctuation

Value	Count	Frequency (%)
)	1212	95.8%
]	35	2.8%
}	9	0.7%
】	6	0.5%
》	3	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	1091	95.5%
[	34	3.0%
{	9	0.8%
【	6	0.5%
《	3	0.3%

Dash Punctuation

Value	Count	Frequency (%)
-	5438	98.9%
—	39	0.7%
–	21	0.4%
―	1	< 0.1%

Modifier Letter

Value	Count	Frequency (%)
ﾞ	11	57.9%
ｰ	6	31.6%
ﾟ	2	10.5%

Modifier Symbol

Value	Count	Frequency (%)
^	8	57.1%
´	3	21.4%
`	3	21.4%

Space Separator

Value	Count	Frequency (%)
	199762	> 99.9%
	2	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	166	82.2%
”	36	17.8%

Nonspacing Mark

Value	Count	Frequency (%)
️	154	92.2%
︎	13	7.8%

Initial Punctuation

Value	Count	Frequency (%)
“	38	84.4%
‘	7	15.6%

Connector Punctuation

Value	Count	Frequency (%)
_	32	97.0%
‿	1	3.0%

Control

Value	Count	Frequency (%)
	157	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	76	100.0%

Other Number

Value	Count	Frequency (%)
²	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1175598	81.9%
Common	257674	18.0%
Han	1732	0.1%
Inherited	167	< 0.1%
Cyrillic	71	< 0.1%
Katakana	64	< 0.1%
Hangul	51	< 0.1%
Hiragana	34	< 0.1%
Georgian	13	< 0.1%
Hebrew	10	< 0.1%

Most frequent character per script

Han

Value	Count	Frequency (%)
房	70	4.0%
中	38	2.2%
家	37	2.1%
拉	35	2.0%
法	34	2.0%
盛	34	2.0%
间	32	1.8%
的	29	1.7%
约	23	1.3%
心	23	1.3%
Other values (352)	1377	79.5%

Common

Value	Count	Frequency (%)
	199762	77.5%
,	7341	2.8%
1	6577	2.6%
!	6408	2.5%
-	5438	2.1%
2	5348	2.1%
/	4070	1.6%
.	3560	1.4%
&	2719	1.1%
3	1986	0.8%
Other values (117)	14465	5.6%

Latin

Value	Count	Frequency (%)
e	98850	8.4%
o	97484	8.3%
t	84336	7.2%
a	82792	7.0%
r	77952	6.6%
i	75406	6.4%
n	75298	6.4%
l	41039	3.5%
m	39024	3.3%
s	38348	3.3%
Other values (67)	465069	39.6%

Hangul

Value	Count	Frequency (%)
한	6	11.8%
웃	3	5.9%
성	3	5.9%
하	2	3.9%
소	2	3.9%
물	2	3.9%
따	2	3.9%
작	2	3.9%
은	2	3.9%
건	2	3.9%
Other values (24)	25	49.0%

Katakana

Value	Count	Frequency (%)
ﾝ	8	12.5%
ｸ	6	9.4%
ﾄ	5	7.8%
ｳ	4	6.2%
ｽ	4	6.2%
ｯ	4	6.2%
ﾘ	3	4.7%
ﾊ	3	4.7%
ﾀ	3	4.7%
ﾌ	2	3.1%
Other values (18)	22	34.4%

Cyrillic

Value	Count	Frequency (%)
о	7	9.9%
к	7	9.9%
а	7	9.9%
с	6	8.5%
р	5	7.0%
н	4	5.6%
е	4	5.6%
м	3	4.2%
и	3	4.2%
у	3	4.2%
Other values (13)	22	31.0%

Hiragana

Value	Count	Frequency (%)
の	7	20.6%
い	4	11.8%
で	4	11.8%
お	4	11.8%
か	2	5.9%
す	2	5.9%
な	1	2.9%
る	1	2.9%
み	1	2.9%
ら	1	2.9%
Other values (7)	7	20.6%

Hebrew

Value	Count	Frequency (%)
ע	2	20.0%
ב	2	20.0%
ר	2	20.0%
י	2	20.0%
ת	2	20.0%

Inherited

Value	Count	Frequency (%)
️	154	92.2%
︎	13	7.8%

Georgian

Value	Count	Frequency (%)
ღ	13	100.0%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1431964	99.8%
CJK	1732	0.1%
Misc Symbols	427	< 0.1%
Punctuation	368	< 0.1%
None	307	< 0.1%
Dingbats	248	< 0.1%
VS	167	< 0.1%
Cyrillic	71	< 0.1%
Hangul	51	< 0.1%
Hiragana	34	< 0.1%
Other values (7)	47	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	199762	14.0%
e	98850	6.9%
o	97484	6.8%
t	84336	5.9%
a	82792	5.8%
r	77952	5.4%
i	75406	5.3%
n	75298	5.3%
l	41039	2.9%
m	39024	2.7%
Other values (86)	560021	39.1%

Misc Symbols

Value	Count	Frequency (%)
★	232	54.3%
☆	100	23.4%
♥	32	7.5%
☀	12	2.8%
⚡	6	1.4%
♦	6	1.4%
♡	6	1.4%
♛	4	0.9%
♕	4	0.9%
⚓	4	0.9%
Other values (11)	21	4.9%

Punctuation

Value	Count	Frequency (%)
’	166	45.1%
•	59	16.0%
—	39	10.6%
“	38	10.3%
”	36	9.8%
–	21	5.7%
‘	7	1.9%
―	1	0.3%
‿	1	0.3%

Dingbats

Value	Count	Frequency (%)
❤	154	62.1%
✨	17	6.9%
✿	13	5.2%
✴	11	4.4%
✪	8	3.2%
✌	6	2.4%
➡	5	2.0%
✰	5	2.0%
✦	4	1.6%
✺	4	1.6%
Other values (10)	21	8.5%

VS

Value	Count	Frequency (%)
️	154	92.2%
︎	13	7.8%

CJK

Value	Count	Frequency (%)
房	70	4.0%
中	38	2.2%
家	37	2.1%
拉	35	2.0%
法	34	2.0%
盛	34	2.0%
间	32	1.8%
的	29	1.7%
约	23	1.3%
心	23	1.3%
Other values (352)	1377	79.5%

None

Value	Count	Frequency (%)
⭐	34	11.1%
à	25	8.1%
ó	18	5.9%
｡	14	4.6%
é	14	4.6%
ﾞ	11	3.6%
·	11	3.6%
ﾝ	8	2.6%
ä	7	2.3%
²	7	2.3%
Other values (64)	158	51.5%

Georgian

Value	Count	Frequency (%)
ღ	13	100.0%

Hiragana

Value	Count	Frequency (%)
の	7	20.6%
い	4	11.8%
で	4	11.8%
お	4	11.8%
か	2	5.9%
す	2	5.9%
な	1	2.9%
る	1	2.9%
み	1	2.9%
ら	1	2.9%
Other values (7)	7	20.6%

Cyrillic

Value	Count	Frequency (%)
о	7	9.9%
к	7	9.9%
а	7	9.9%
с	6	8.5%
р	5	7.0%
н	4	5.6%
е	4	5.6%
м	3	4.2%
и	3	4.2%
у	3	4.2%
Other values (13)	22	31.0%

Hangul

Value	Count	Frequency (%)
한	6	11.8%
웃	3	5.9%
성	3	5.9%
하	2	3.9%
소	2	3.9%
물	2	3.9%
따	2	3.9%
작	2	3.9%
은	2	3.9%
건	2	3.9%
Other values (24)	25	49.0%

Geometric Shapes

Value	Count	Frequency (%)
▲	4	40.0%
△	2	20.0%
◔	2	20.0%
◈	2	20.0%

Math Operators

Value	Count	Frequency (%)
⋆	3	50.0%
√	2	33.3%
⊹	1	16.7%

Misc Technical

Value	Count	Frequency (%)
⍟	2	40.0%
⌚	1	20.0%
⏩	1	20.0%
⏪	1	20.0%

Hebrew

Value	Count	Frequency (%)
ע	2	20.0%
ב	2	20.0%
ר	2	20.0%
י	2	20.0%
ת	2	20.0%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Letterlike Symbols

Value	Count	Frequency (%)
™	1	100.0%

host_id
Real number (ℝ)

Distinct	30232
Distinct (%)	77.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64245819

Minimum	2438
Maximum	2.7384167 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	2438
5-th percentile	709939
Q1	7029525
median	28370925
Q3	1.0189055 × 10⁸
95-th percentile	2.3020517 × 10⁸
Maximum	2.7384167 × 10⁸
Range	2.7383923 × 10⁸
Interquartile range (IQR)	94861021

Descriptive statistics

Standard deviation	75897516
Coefficient of variation (CV)	1.1813612
Kurtosis	0.30524294
Mean	64245819
Median Absolute Deviation (MAD)	25472582
Skewness	1.2479603
Sum	2.4940869 × 10¹²
Variance	5.760433 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	207	0.5%
61391963	79	0.2%
16098958	61	0.2%
137358866	51	0.1%
7503643	49	0.1%
190921808	46	0.1%
30283594	43	0.1%
1475015	42	0.1%
120762452	40	0.1%
2119276	39	0.1%
Other values (30222)	38164	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2438	1	< 0.1%
2571	1	< 0.1%
2787	6	< 0.1%
2845	2	< 0.1%
2868	1	< 0.1%
2881	2	< 0.1%
3151	1	< 0.1%
3211	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%

Value	Count	Frequency (%)
273841667	1	< 0.1%
273361532	1	< 0.1%
272872092	1	< 0.1%
272816114	1	< 0.1%
272557707	1	< 0.1%
272327753	1	< 0.1%
272314085	1	< 0.1%
272308792	1	< 0.1%
272241217	1	< 0.1%
271928929	1	< 0.1%

host_name
Categorical

Distinct	9885
Distinct (%)	25.5%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

Michael	335
David	309
John	250
Alex	229
Sonder (NYC)	207
Other values (9880)	37491

Length

Max length	35
Median length	31
Mean length	6.1247005
Min length	1

Characters and Unicode

Total characters	237767
Distinct characters	164
Distinct categories	15 ?
Distinct scripts	6 ?
Distinct blocks	8 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6005 ?
Unique (%)	15.5%

Sample

1st row	John
2nd row	Jennifer
3rd row	LisaRoxanne
4th row	Laura
5th row	Chris

Common Values

Value	Count	Frequency (%)
Michael	335	0.9%
David	309	0.8%
John	250	0.6%
Alex	229	0.6%
Sonder (NYC)	207	0.5%
Sarah	179	0.5%
Maria	174	0.4%
Jessica	170	0.4%
Daniel	170	0.4%
Anna	159	0.4%
Other values (9875)	36639	94.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	974	2.2%
and	580	1.3%
michael	375	0.9%
david	348	0.8%
john	288	0.7%
alex	277	0.6%
sonder	236	0.5%
nyc	215	0.5%
laura	214	0.5%
maria	206	0.5%
Other values (8860)	39883	91.5%

Most occurring characters

Value	Count	Frequency (%)
a	30311	12.7%
e	22652	9.5%
i	19642	8.3%
n	19283	8.1%
r	13903	5.8%
l	12122	5.1%
o	9977	4.2%
s	7496	3.2%
t	7479	3.1%
h	7249	3.0%
Other values (154)	87653	36.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	186978	78.6%
Uppercase Letter	43660	18.4%
Space Separator	4871	2.0%
Other Punctuation	1403	0.6%
Open Punctuation	257	0.1%
Close Punctuation	255	0.1%
Dash Punctuation	176	0.1%
Decimal Number	65	< 0.1%
Other Letter	63	< 0.1%
Math Symbol	31	< 0.1%
Other values (5)	8	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	30311	16.2%
e	22652	12.1%
i	19642	10.5%
n	19283	10.3%
r	13903	7.4%
l	12122	6.5%
o	9977	5.3%
s	7496	4.0%
t	7479	4.0%
h	7249	3.9%
Other values (49)	36864	19.7%

Other Letter

Value	Count	Frequency (%)
明	6	9.5%
青	5	7.9%
德	5	7.9%
美	5	7.9%
常	3	4.8%
春	3	4.8%
正	2	3.2%
川	2	3.2%
威	1	1.6%
思	1	1.6%
Other values (30)	30	47.6%

Uppercase Letter

Value	Count	Frequency (%)
A	5277	12.1%
J	4467	10.2%
M	4299	9.8%
S	3696	8.5%
C	2988	6.8%
L	2332	5.3%
D	2171	5.0%
R	2023	4.6%
K	1999	4.6%
E	1909	4.4%
Other values (23)	12499	28.6%

Other Punctuation

Value	Count	Frequency (%)
&	1015	72.3%
.	274	19.5%
/	38	2.7%
,	32	2.3%
'	23	1.6%
@	7	0.5%
"	6	0.4%
!	4	0.3%
:	2	0.1%
#	1	0.1%

Decimal Number

Value	Count	Frequency (%)
5	18	27.7%
7	11	16.9%
0	10	15.4%
2	7	10.8%
1	6	9.2%
4	5	7.7%
6	3	4.6%
3	3	4.6%
8	1	1.5%
9	1	1.5%

Space Separator

Value	Count	Frequency (%)
	4867	99.9%
	4	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	257	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	255	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	176	100.0%

Math Symbol

Value	Count	Frequency (%)
+	31	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	2	100.0%

Format

Value	Count	Frequency (%)
	2	100.0%

Other Symbol

Value	Count	Frequency (%)
★	2	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	230619	97.0%
Common	7066	3.0%
Han	54	< 0.1%
Cyrillic	19	< 0.1%
Hebrew	5	< 0.1%
Hangul	4	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	30311	13.1%
e	22652	9.8%
i	19642	8.5%
n	19283	8.4%
r	13903	6.0%
l	12122	5.3%
o	9977	4.3%
s	7496	3.3%
t	7479	3.2%
h	7249	3.1%
Other values (70)	80505	34.9%

Common

Value	Count	Frequency (%)
	4867	68.9%
&	1015	14.4%
.	274	3.9%
(	257	3.6%
)	255	3.6%
-	176	2.5%
/	38	0.5%
,	32	0.5%
+	31	0.4%
'	23	0.3%
Other values (22)	98	1.4%

Han

Value	Count	Frequency (%)
明	6	11.1%
青	5	9.3%
德	5	9.3%
美	5	9.3%
常	3	5.6%
春	3	5.6%
正	2	3.7%
川	2	3.7%
威	1	1.9%
思	1	1.9%
Other values (21)	21	38.9%

Cyrillic

Value	Count	Frequency (%)
н	3	15.8%
а	3	15.8%
А	2	10.5%
Т	2	10.5%
и	2	10.5%
р	1	5.3%
л	1	5.3%
е	1	5.3%
к	1	5.3%
с	1	5.3%
Other values (2)	2	10.5%

Hebrew

Value	Count	Frequency (%)
ד	1	20.0%
נ	1	20.0%
י	1	20.0%
א	1	20.0%
ל	1	20.0%

Hangul

Value	Count	Frequency (%)
빈	1	25.0%
정	1	25.0%
소	1	25.0%
나	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237472	99.9%
None	203	0.1%
CJK	54	< 0.1%
Cyrillic	19	< 0.1%
Punctuation	8	< 0.1%
Hebrew	5	< 0.1%
Hangul	4	< 0.1%
Misc Symbols	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	30311	12.8%
e	22652	9.5%
i	19642	8.3%
n	19283	8.1%
r	13903	5.9%
l	12122	5.1%
o	9977	4.2%
s	7496	3.2%
t	7479	3.1%
h	7249	3.1%
Other values (69)	87358	36.8%

None

Value	Count	Frequency (%)
é	84	41.4%
í	18	8.9%
ú	18	8.9%
á	17	8.4%
ë	11	5.4%
ô	9	4.4%
ó	8	3.9%
è	6	3.0%
ç	5	2.5%
ï	4	2.0%
Other values (19)	23	11.3%

CJK

Value	Count	Frequency (%)
明	6	11.1%
青	5	9.3%
德	5	9.3%
美	5	9.3%
常	3	5.6%
春	3	5.6%
正	2	3.7%
川	2	3.7%
威	1	1.9%
思	1	1.9%
Other values (21)	21	38.9%

Punctuation

Value	Count	Frequency (%)
	4	50.0%
’	2	25.0%
	2	25.0%

Cyrillic

Value	Count	Frequency (%)
н	3	15.8%
а	3	15.8%
А	2	10.5%
Т	2	10.5%
и	2	10.5%
р	1	5.3%
л	1	5.3%
е	1	5.3%
к	1	5.3%
с	1	5.3%
Other values (2)	2	10.5%

Misc Symbols

Value	Count	Frequency (%)
★	2	100.0%

Hangul

Value	Count	Frequency (%)
빈	1	25.0%
정	1	25.0%
소	1	25.0%
나	1	25.0%

Hebrew

Value	Count	Frequency (%)
ד	1	20.0%
נ	1	20.0%
י	1	20.0%
א	1	20.0%
ל	1	20.0%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

Manhattan	16621
Brooklyn	16439
Queens	4572
Bronx	875
Staten Island	314

Length

Max length	13
Median length	9
Mean length	8.1654259
Min length	5

Characters and Unicode

Total characters	316990
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brooklyn
2nd row	Manhattan
3rd row	Brooklyn
4th row	Manhattan
5th row	Manhattan

Common Values

Value	Count	Frequency (%)
Manhattan	16621	42.8%
Brooklyn	16439	42.3%
Queens	4572	11.8%
Bronx	875	2.3%
Staten Island	314	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	16621	42.5%
brooklyn	16439	42.0%
queens	4572	11.7%
bronx	875	2.2%
staten	314	0.8%
island	314	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	55756	17.6%
a	50491	15.9%
t	33870	10.7%
o	33753	10.6%
B	17314	5.5%
r	17314	5.5%
l	16753	5.3%
M	16621	5.2%
h	16621	5.2%
y	16439	5.2%
Other values (10)	42058	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	277541	87.6%
Uppercase Letter	39135	12.3%
Space Separator	314	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	55756	20.1%
a	50491	18.2%
t	33870	12.2%
o	33753	12.2%
r	17314	6.2%
l	16753	6.0%
h	16621	6.0%
y	16439	5.9%
k	16439	5.9%
e	9458	3.4%
Other values (4)	10647	3.8%

Uppercase Letter

Value	Count	Frequency (%)
B	17314	44.2%
M	16621	42.5%
Q	4572	11.7%
S	314	0.8%
I	314	0.8%

Space Separator

Value	Count	Frequency (%)
	314	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	316676	99.9%
Common	314	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	55756	17.6%
a	50491	15.9%
t	33870	10.7%
o	33753	10.7%
B	17314	5.5%
r	17314	5.5%
l	16753	5.3%
M	16621	5.2%
h	16621	5.2%
y	16439	5.2%
Other values (9)	41744	13.2%

Common

Value	Count	Frequency (%)
	314	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	316990	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	55756	17.6%
a	50491	15.9%
t	33870	10.7%
o	33753	10.6%
B	17314	5.5%
r	17314	5.5%
l	16753	5.3%
M	16621	5.2%
h	16621	5.2%
y	16439	5.2%
Other values (10)	42058	13.3%

neighbourhood
Categorical

Distinct	218
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

Williamsburg	3163
Bedford-Stuyvesant	3141
Harlem	2204
Bushwick	1942
Hell's Kitchen	1528
Other values (213)	26843

Length

Max length	26
Median length	17
Mean length	11.928235
Min length	4

Characters and Unicode

Total characters	463066
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Kensington
2nd row	Midtown
3rd row	Clinton Hill
4th row	East Harlem
5th row	Murray Hill

Common Values

Value	Count	Frequency (%)
Williamsburg	3163	8.1%
Bedford-Stuyvesant	3141	8.1%
Harlem	2204	5.7%
Bushwick	1942	5.0%
Hell's Kitchen	1528	3.9%
East Village	1489	3.8%
Upper West Side	1482	3.8%
Upper East Side	1405	3.6%
Crown Heights	1265	3.3%
Midtown	986	2.5%
Other values (208)	20216	52.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	5374	8.6%
side	3625	5.8%
williamsburg	3163	5.0%
harlem	3147	5.0%
bedford-stuyvesant	3141	5.0%
heights	2889	4.6%
upper	2887	4.6%
village	2522	4.0%
west	2110	3.4%
bushwick	1942	3.1%
Other values (231)	31858	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	42598	9.2%
i	32780	7.1%
s	31811	6.9%
t	30583	6.6%
a	30156	6.5%
l	27652	6.0%
r	26841	5.8%
	23837	5.1%
n	20721	4.5%
o	19240	4.2%
Other values (44)	176847	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	367305	79.3%
Uppercase Letter	66693	14.4%
Space Separator	23837	5.1%
Dash Punctuation	3592	0.8%
Other Punctuation	1639	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	42598	11.6%
i	32780	8.9%
s	31811	8.7%
t	30583	8.3%
a	30156	8.2%
l	27652	7.5%
r	26841	7.3%
n	20721	5.6%
o	19240	5.2%
d	15627	4.3%
Other values (15)	89296	24.3%

Uppercase Letter

Value	Count	Frequency (%)
H	9622	14.4%
S	9306	14.0%
B	6776	10.2%
W	6470	9.7%
E	5790	8.7%
C	4256	6.4%
G	2991	4.5%
U	2933	4.4%
F	2597	3.9%
V	2557	3.8%
Other values (14)	13395	20.1%

Other Punctuation

Value	Count	Frequency (%)
'	1533	93.5%
.	104	6.3%
,	2	0.1%

Space Separator

Value	Count	Frequency (%)
	23837	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3592	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	433998	93.7%
Common	29068	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	42598	9.8%
i	32780	7.6%
s	31811	7.3%
t	30583	7.0%
a	30156	6.9%
l	27652	6.4%
r	26841	6.2%
n	20721	4.8%
o	19240	4.4%
d	15627	3.6%
Other values (39)	155989	35.9%

Common

Value	Count	Frequency (%)
	23837	82.0%
-	3592	12.4%
'	1533	5.3%
.	104	0.4%
,	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	463066	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	42598	9.2%
i	32780	7.1%
s	31811	6.9%
t	30583	6.6%
a	30156	6.5%
l	27652	6.0%
r	26841	5.8%
	23837	5.1%
n	20721	4.5%
o	19240	4.2%
Other values (44)	176847	38.2%

latitude
Real number (ℝ)

Distinct	17436
Distinct (%)	44.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728129

Minimum	40.50641
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	40.50641
5-th percentile	40.64567
Q1	40.68864
median	40.72171
Q3	40.76299
95-th percentile	40.82605
Maximum	40.91306
Range	0.40665
Interquartile range (IQR)	0.07435

Descriptive statistics

Standard deviation	0.054990741
Coefficient of variation (CV)	0.0013501907
Kurtosis	0.095032403
Mean	40.728129
Median Absolute Deviation (MAD)	0.03641
Skewness	0.2725179
Sum	1581106.7
Variance	0.0030239816
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	15	< 0.1%
40.69414	11	< 0.1%
40.68634	11	< 0.1%
40.71353	11	< 0.1%
40.71515	10	< 0.1%
40.68374	10	< 0.1%
40.67757	10	< 0.1%
40.68444	10	< 0.1%
40.69054	10	< 0.1%
40.71947	10	< 0.1%
Other values (17426)	38713	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50641	1	< 0.1%
40.50868	1	< 0.1%
40.50873	1	< 0.1%
40.50943	1	< 0.1%
40.51133	1	< 0.1%
40.52211	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53982	1	< 0.1%
40.53987	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.91234	1	< 0.1%
40.91167	1	< 0.1%
40.90804	1	< 0.1%
40.90484	1	< 0.1%
40.90406	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90175	1	< 0.1%

longitude
Real number (ℝ)

Distinct	13639
Distinct (%)	35.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.951149

Minimum	-74.24442
Maximum	-73.71299
Zeros	0
Zeros (%)	0.0%
Negative	38821
Negative (%)	100.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	-74.24442
5-th percentile	-74.00329
Q1	-73.98246
median	-73.95481
Q3	-73.93502
95-th percentile	-73.86217
Maximum	-73.71299
Range	0.53143
Interquartile range (IQR)	0.04744

Descriptive statistics

Standard deviation	0.046692964
Coefficient of variation (CV)	-0.00063140282
Kurtosis	4.8048546
Mean	-73.951149
Median Absolute Deviation (MAD)	0.02492
Skewness	1.2562663
Sum	-2870857.5
Variance	0.0021802329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.95427	16	< 0.1%
-73.95677	16	< 0.1%
-73.95405	15	< 0.1%
-73.95551	14	< 0.1%
-73.95742	14	< 0.1%
-73.9506	14	< 0.1%
-73.95688	13	< 0.1%
-73.943	13	< 0.1%
-73.9398	13	< 0.1%
-73.95669	13	< 0.1%
Other values (13629)	38680	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.24442	1	< 0.1%
-74.23986	1	< 0.1%
-74.23914	1	< 0.1%
-74.23803	1	< 0.1%
-74.23059	1	< 0.1%
-74.21238	1	< 0.1%
-74.21017	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.18028	1	< 0.1%

Value	Count	Frequency (%)
-73.71299	1	< 0.1%
-73.71928	1	< 0.1%
-73.72179	1	< 0.1%
-73.72435	1	< 0.1%
-73.72581	1	< 0.1%
-73.72582	1	< 0.1%
-73.72597	1	< 0.1%
-73.726	1	< 0.1%
-73.72656	1	< 0.1%
-73.72716	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

Entire home/apt	20321
Private room	17654
Shared room	846

Length

Max length	15
Median length	15
Mean length	13.548569
Min length	11

Characters and Unicode

Total characters	525969
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	20321	52.3%
Private room	17654	45.5%
Shared room	846	2.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	20321	26.2%
home/apt	20321	26.2%
room	18500	23.8%
private	17654	22.7%
shared	846	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	59142	11.2%
t	58296	11.1%
o	57321	10.9%
r	57321	10.9%
a	38821	7.4%
	38821	7.4%
m	38821	7.4%
i	37975	7.2%
h	21167	4.0%
p	20321	3.9%
Other values (7)	97963	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	428006	81.4%
Space Separator	38821	7.4%
Uppercase Letter	38821	7.4%
Other Punctuation	20321	3.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	59142	13.8%
t	58296	13.6%
o	57321	13.4%
r	57321	13.4%
a	38821	9.1%
m	38821	9.1%
i	37975	8.9%
h	21167	4.9%
p	20321	4.7%
n	20321	4.7%
Other values (2)	18500	4.3%

Uppercase Letter

Value	Count	Frequency (%)
E	20321	52.3%
P	17654	45.5%
S	846	2.2%

Space Separator

Value	Count	Frequency (%)
	38821	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	20321	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	466827	88.8%
Common	59142	11.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	59142	12.7%
t	58296	12.5%
o	57321	12.3%
r	57321	12.3%
a	38821	8.3%
m	38821	8.3%
i	37975	8.1%
h	21167	4.5%
p	20321	4.4%
E	20321	4.4%
Other values (5)	57321	12.3%

Common

Value	Count	Frequency (%)
	38821	65.6%
/	20321	34.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	525969	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	59142	11.2%
t	58296	11.1%
o	57321	10.9%
r	57321	10.9%
a	38821	7.4%
	38821	7.4%
m	38821	7.4%
i	37975	7.2%
h	21167	4.0%
p	20321	3.9%
Other values (7)	97963	18.6%

price
Real number (ℝ)

Distinct	581
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	142.33253

Minimum	0
Maximum	10000
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	69
median	101
Q3	170
95-th percentile	330
Maximum	10000
Range	10000
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	196.99476
Coefficient of variation (CV)	1.3840459
Kurtosis	953.48074
Mean	142.33253
Median Absolute Deviation (MAD)	45
Skewness	23.673594
Sum	5525491
Variance	38806.934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	1596	4.1%
100	1517	3.9%
50	1188	3.1%
60	1155	3.0%
75	1095	2.8%
200	1025	2.6%
80	1022	2.6%
65	1006	2.6%
70	938	2.4%
120	921	2.4%
Other values (571)	27358	70.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
10	12	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	3	< 0.1%
16	5	< 0.1%
18	1	< 0.1%
19	4	< 0.1%
20	23	0.1%

Value	Count	Frequency (%)
10000	2	< 0.1%
9999	2	< 0.1%
8500	1	< 0.1%
8000	1	< 0.1%
7500	1	< 0.1%
6000	1	< 0.1%
5100	1	< 0.1%
5000	5	< 0.1%
4500	1	< 0.1%
3900	1	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	89
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8692203

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	17.389026
Coefficient of variation (CV)	2.962749
Kurtosis	1381.6227
Mean	5.8692203
Median Absolute Deviation (MAD)	1
Skewness	27.542187
Sum	227849
Variance	302.37823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	10300	26.5%
1	9878	25.4%
3	6840	17.6%
4	2749	7.1%
5	2425	6.2%
30	2300	5.9%
7	1453	3.7%
6	612	1.6%
14	380	1.0%
10	343	0.9%
Other values (79)	1541	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9878	25.4%
2	10300	26.5%
3	6840	17.6%
4	2749	7.1%
5	2425	6.2%
6	612	1.6%
7	1453	3.7%
8	102	0.3%
9	62	0.2%
10	343	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
500	2	< 0.1%
370	1	< 0.1%
365	19	< 0.1%
364	1	< 0.1%
360	1	< 0.1%
300	3	< 0.1%
270	2	< 0.1%
265	1	< 0.1%

number_of_reviews
Real number (ℝ)

Distinct	393
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.290255

Minimum	1
Maximum	629
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	9
Q3	33
95-th percentile	129
Maximum	629
Range	628
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	48.1829
Coefficient of variation (CV)	1.6450147
Kurtosis	15.966318
Mean	29.290255
Median Absolute Deviation (MAD)	8
Skewness	3.325293
Sum	1137077
Variance	2321.5918
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5239	13.5%
2	3464	8.9%
3	2519	6.5%
4	1994	5.1%
5	1615	4.2%
6	1356	3.5%
7	1179	3.0%
8	1127	2.9%
9	964	2.5%
10	803	2.1%
Other values (383)	18561	47.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5239	13.5%
2	3464	8.9%
3	2519	6.5%
4	1994	5.1%
5	1615	4.2%
6	1356	3.5%
7	1179	3.0%
8	1127	2.9%
9	964	2.5%
10	803	2.1%

Value	Count	Frequency (%)
629	1	< 0.1%
607	1	< 0.1%
597	1	< 0.1%
594	1	< 0.1%
576	1	< 0.1%
543	1	< 0.1%
540	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
480	1	< 0.1%

last_review
Categorical

Distinct	1764
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	606.6 KiB

23-06-2019	1413
01-07-2019	1359
30-06-2019	1341
24-06-2019	875
07-07-2019	717
Other values (1759)	33116

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	388210
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	236 ?
Unique (%)	0.6%

Sample

1st row	19-10-2018
2nd row	21-05-2019
3rd row	05-07-2019
4th row	19-11-2018
5th row	22-06-2019

Common Values

Value	Count	Frequency (%)
23-06-2019	1413	3.6%
01-07-2019	1359	3.5%
30-06-2019	1341	3.5%
24-06-2019	875	2.3%
07-07-2019	717	1.8%
02-07-2019	657	1.7%
22-06-2019	655	1.7%
16-06-2019	601	1.5%
05-07-2019	580	1.5%
06-07-2019	565	1.5%
Other values (1754)	30058	77.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
23-06-2019	1413	3.6%
01-07-2019	1359	3.5%
30-06-2019	1341	3.5%
24-06-2019	875	2.3%
07-07-2019	717	1.8%
02-07-2019	657	1.7%
22-06-2019	655	1.7%
16-06-2019	601	1.5%
05-07-2019	580	1.5%
06-07-2019	565	1.5%
Other values (1754)	30058	77.4%

Most occurring characters

Value	Count	Frequency (%)
0	92276	23.8%
-	77642	20.0%
1	61982	16.0%
2	58655	15.1%
9	30096	7.8%
6	19883	5.1%
7	12817	3.3%
8	10828	2.8%
5	9569	2.5%
3	8762	2.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	310568	80.0%
Dash Punctuation	77642	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	92276	29.7%
1	61982	20.0%
2	58655	18.9%
9	30096	9.7%
6	19883	6.4%
7	12817	4.1%
8	10828	3.5%
5	9569	3.1%
3	8762	2.8%
4	5700	1.8%

Dash Punctuation

Value	Count	Frequency (%)
-	77642	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	388210	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	92276	23.8%
-	77642	20.0%
1	61982	16.0%
2	58655	15.1%
9	30096	7.8%
6	19883	5.1%
7	12817	3.3%
8	10828	2.8%
5	9569	2.5%
3	8762	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	388210	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	92276	23.8%
-	77642	20.0%
1	61982	16.0%
2	58655	15.1%
9	30096	7.8%
6	19883	5.1%
7	12817	3.3%
8	10828	2.8%
5	9569	2.5%
3	8762	2.3%

reviews_per_month
Real number (ℝ)

Distinct	937
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3732292

Minimum	0.01
Maximum	58.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.02
95-th percentile	4.64
Maximum	58.5
Range	58.49
Interquartile range (IQR)	1.83

Descriptive statistics

Standard deviation	1.6803278
Coefficient of variation (CV)	1.2236324
Kurtosis	42.528736
Mean	1.3732292
Median Absolute Deviation (MAD)	0.62
Skewness	3.1315634
Sum	53310.13
Variance	2.8235014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	914	2.4%
0.05	892	2.3%
1	892	2.3%
0.03	804	2.1%
0.16	667	1.7%
0.04	655	1.7%
0.08	596	1.5%
0.09	592	1.5%
0.06	579	1.5%
0.11	539	1.4%
Other values (927)	31691	81.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	42	0.1%
0.02	914	2.4%
0.03	804	2.1%
0.04	655	1.7%
0.05	892	2.3%
0.06	579	1.5%
0.07	465	1.2%
0.08	596	1.5%
0.09	592	1.5%
0.1	457	1.2%

Value	Count	Frequency (%)
58.5	1	< 0.1%
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.81	1	< 0.1%
16.22	1	< 0.1%
16.03	1	< 0.1%
15.78	1	< 0.1%
15.32	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	47
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1666109

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	9
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	26.302954
Coefficient of variation (CV)	5.0909494
Kurtosis	121.90908
Mean	5.1666109
Median Absolute Deviation (MAD)	0
Skewness	10.628207
Sum	200573
Variance	691.8454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	25334	65.3%
2	5757	14.8%
3	2494	6.4%
4	1282	3.3%
5	736	1.9%
6	476	1.2%
7	318	0.8%
8	317	0.8%
327	207	0.5%
9	187	0.5%
Other values (37)	1713	4.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	25334	65.3%
2	5757	14.8%
3	2494	6.4%
4	1282	3.3%
5	736	1.9%
6	476	1.2%
7	318	0.8%
8	317	0.8%
9	187	0.5%
10	148	0.4%

Value	Count	Frequency (%)
327	207	0.5%
232	28	0.1%
121	43	0.1%
103	51	0.1%
96	90	0.2%
91	79	0.2%
87	39	0.1%
65	1	< 0.1%
52	91	0.2%
50	40	0.1%

availability_365
Real number (ℝ)

Distinct	366
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.8863

Minimum	0
Maximum	365
Zeros	12675
Zeros (%)	32.6%
Negative	0
Negative (%)	0.0%
Memory size	606.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	55
Q3	229
95-th percentile	356
Maximum	365
Range	365
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	129.52995
Coefficient of variation (CV)	1.1274621
Kurtosis	-1.0296509
Mean	114.8863
Median Absolute Deviation (MAD)	55
Skewness	0.72321806
Sum	4460001
Variance	16778.008
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12675	32.6%
365	841	2.2%
1	367	0.9%
364	301	0.8%
5	291	0.7%
3	278	0.7%
89	257	0.7%
2	240	0.6%
90	221	0.6%
179	216	0.6%
Other values (356)	23134	59.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12675	32.6%
1	367	0.9%
2	240	0.6%
3	278	0.7%
4	209	0.5%
5	291	0.7%
6	212	0.5%
7	187	0.5%
8	207	0.5%
9	162	0.4%

Value	Count	Frequency (%)
365	841	2.2%
364	301	0.8%
363	165	0.4%
362	118	0.3%
361	90	0.2%
360	77	0.2%
359	99	0.3%
358	132	0.3%
357	78	0.2%
356	66	0.2%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood_group	room_type
id	1.000	0.566	-0.005	0.088	-0.050	-0.155	-0.303	0.360	0.091	0.074	0.063	0.078
host_id	0.566	1.000	0.039	0.130	-0.097	-0.185	-0.105	0.268	0.124	0.131	0.100	0.099
latitude	-0.005	0.039	1.000	0.041	0.118	0.017	-0.025	-0.023	-0.011	-0.021	0.537	0.110
longitude	0.088	0.130	0.041	1.000	-0.433	-0.120	0.070	0.119	0.106	0.094	0.653	0.148
price	-0.050	-0.097	0.118	-0.433	1.000	0.117	-0.010	-0.019	-0.164	0.064	0.014	0.023
minimum_nights	-0.155	-0.185	0.017	-0.120	0.117	1.000	-0.168	-0.289	-0.008	0.015	0.001	0.004
number_of_reviews	-0.303	-0.105	-0.025	0.070	-0.010	-0.168	1.000	0.706	0.083	0.296	0.026	0.023
reviews_per_month	0.360	0.268	-0.023	0.119	-0.019	-0.289	0.706	1.000	0.146	0.392	0.048	0.029
calculated_host_listings_count	0.091	0.124	-0.011	0.106	-0.164	-0.008	0.083	0.146	1.000	0.369	0.071	0.074
availability_365	0.074	0.131	-0.021	0.094	0.064	0.015	0.296	0.392	0.369	1.000	0.086	0.096
neighbourhood_group	0.063	0.100	0.537	0.653	0.014	0.001	0.026	0.048	0.071	0.086	1.000	0.111
room_type	0.078	0.099	0.110	0.148	0.023	0.004	0.023	0.029	0.074	0.096	0.111	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	2539	Clean & quiet apt home by the park	2787	John	Brooklyn	Kensington	40.65	-73.97	Private room	149	1	9	19-10-2018	0.21	6	365
1	2595	Skylit Midtown Castle	2845	Jennifer	Manhattan	Midtown	40.75	-73.98	Entire home/apt	225	1	45	21-05-2019	0.38	2	355
3	3831	Cozy Entire Floor of Brownstone	4869	LisaRoxanne	Brooklyn	Clinton Hill	40.69	-73.96	Entire home/apt	89	1	270	05-07-2019	4.64	1	194
4	5022	Entire Apt: Spacious Studio/Loft by central park	7192	Laura	Manhattan	East Harlem	40.80	-73.94	Entire home/apt	80	10	9	19-11-2018	0.10	1	0
5	5099	Large Cozy 1 BR Apartment In Midtown East	7322	Chris	Manhattan	Murray Hill	40.75	-73.97	Entire home/apt	200	3	74	22-06-2019	0.59	1	129
6	5121	BlissArtsSpace!	7356	Garon	Brooklyn	Bedford-Stuyvesant	40.69	-73.96	Private room	60	45	49	05-10-2017	0.40	1	0
7	5178	Large Furnished Room Near B'way	8967	Shunichi	Manhattan	Hell's Kitchen	40.76	-73.98	Private room	79	2	430	24-06-2019	3.47	1	220
8	5203	Cozy Clean Guest Room - Family Apt	7490	MaryEllen	Manhattan	Upper West Side	40.80	-73.97	Private room	79	2	118	21-07-2017	0.99	1	0
9	5238	Cute & Cozy Lower East Side 1 bdrm	7549	Ben	Manhattan	Chinatown	40.71	-73.99	Entire home/apt	150	1	160	09-06-2019	1.33	4	188
10	5295	Beautiful 1br on Upper West Side	7702	Lena	Manhattan	Upper West Side	40.80	-73.97	Entire home/apt	135	5	53	22-06-2019	0.43	1	6

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
48634	36351128	One bedroom without roomies, close to everything	273361532	David & Amy	Manhattan	Upper West Side	40.80	-73.97	Entire home/apt	110	3	2	05-07-2019	2.00	1	15
48636	36351543	2-MONTH SUBLEASE (WITH EARLY MOVE-IN)	52984497	Friday	Brooklyn	Bedford-Stuyvesant	40.69	-73.92	Private room	33	30	2	06-07-2019	2.00	1	87
48701	36390226	Comfortable clean Bedstuy private room	267932490	Angela	Brooklyn	Bedford-Stuyvesant	40.70	-73.94	Private room	45	1	2	08-07-2019	2.00	1	14
48732	36411407	Brand new 1 bedroom steps from Soho!	33917435	Mike	Manhattan	Lower East Side	40.72	-73.99	Entire home/apt	150	4	1	06-07-2019	1.00	1	13
48740	36413632	Spacious 2BR in Beautiful Brooklyn Heights	6608220	Matt	Brooklyn	Brooklyn Heights	40.70	-74.00	Entire home/apt	550	3	1	07-07-2019	1.00	1	230
48782	36425863	Lovely Privet Bedroom with Privet Restroom	83554966	Rusaa	Manhattan	Upper East Side	40.78	-73.95	Private room	129	1	1	07-07-2019	1.00	1	147
48790	36427429	No.2 with queen size bed	257683179	H Ai	Queens	Flushing	40.75	-73.81	Private room	45	1	1	07-07-2019	1.00	6	339
48799	36438336	Seas The Moment	211644523	Ben	Staten Island	Great Kills	40.54	-74.14	Private room	235	1	1	07-07-2019	1.00	1	87
48805	36442252	1B-1B apartment near by Metro	273841667	Blaine	Bronx	Mott Haven	40.81	-73.92	Entire home/apt	100	1	2	07-07-2019	2.00	1	40
48852	36455809	Cozy Private Room in Bushwick, Brooklyn	74162901	Christine	Brooklyn	Bushwick	40.70	-73.93	Private room	30	1	1	08-07-2019	1.00	1	1

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Other Symbol

Uppercase Letter

Other Punctuation

Math Symbol

Decimal Number

Close Punctuation

Open Punctuation

Dash Punctuation

Modifier Letter

Modifier Symbol

Space Separator

Final Punctuation

Nonspacing Mark

Initial Punctuation

Connector Punctuation

Control

Currency Symbol

Other Number

Most occurring scripts

Most frequent character per script

Han

Common

Latin

Hangul

Katakana

Cyrillic

Hiragana

Hebrew

Inherited

Georgian

Devanagari

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

Dingbats

VS

CJK

None

Georgian

Hiragana

Cyrillic

Hangul

Geometric Shapes

Math Operators

Misc Technical

Hebrew

Devanagari

Letterlike Symbols

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Other Letter

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Math Symbol

Final Punctuation

Format

Other Symbol

Currency Symbol

Connector Punctuation

Most occurring scripts